TRUNCATE TABLE Members;

INSERT INTO Members
 (
  Id
  , UserName
  , Password
  , Email
  , PasswordQuestion
  , PasswordAnswer
  , IsApproved
  , IsLockedOut
  , Comment
  , CreationDate
  , ApplicationName
  , Format
  , AnswerFormat
 )
SELECT
  uuid(),
  Navn,
  Kode,
  Email,
  'Reviewer',
  '@br@kr@d@br@',
  1,
  0
  ,IFNull(OM,''),
  Now(),
  'Reviewer.dk'
  ,0
  ,0
FROM v2_writters;